Production Reporting

Version: As of version 16.03

Purpose

Once Production Jobs have been created and saved, they may be displayed via Production > Job Reporting. Once users navigate to the Job Reporting area they are presented with the Job Reporting pre-filter, which contains over fifteen different available reports. Numerous selection criteria allow users to filter and sort results for conducting detailed production analysis and for grouping orders. Once a report has been generated, users can drill down into specific Jobs to view additional information. Beginning in version 16.02, users have the option of creating user versions of any job report. See the Configuration section for information and links.

Additionally, DEACOM offers the option to generate environmental reports, which can be based on Jobs produced or Sales Orders shipped in a specific date range. For information on using this feature, refer to the Generating Environmental Reports Best Practice page.

Security and Configuration

Security/Permissions See your system administrator for security access. If desired, there are five user-defined fields, called Item Search 1-5, that can be used to filter for reporting. The names for these fields are maintained in System > Maintenance > Captions and the pick lists are maintained in Inventory > Maintenance > Item Search 1-5.

If users are satisfied with the standard system reports, no additional configuration is required. If necessary, users can configure the appropriate production reports, by modifying the report grid and adding, removing, or modifying the fields that will be displayed on the grid reports. Additional information on grid layouts is available via the Configuring Grid Layouts and Automated Reports Best Practice page.

. Beginning in version 16.02, users with permission can create unlimited user versions of any job report and also determine which reports each user can see in the "Report Type" field on the Job Reporting pre-filter. See the Configuring Grid Layouts and Automated Reports and Grid Layout Security pages for information.

Related Processes

Procedures

How are Job Reporting reports generated?

  1. Navigate to Production > Job Reporting.
  2. Select "Production" from the Job Type pick list and complete the remaining Job Reporting pre-filters as desired.
  3. Click the "View" button to display the results.
  4. Users may double-click the column headings to sort the results.
  5. It is possible to create a new job or modify an existing one without leaving the Job Reporting pre-filter. To create a new job, click the “New” button. To modify an existing one, enter a job number and click the “Modify” button.
  6. To view the General Ledger postings for a given Job, click on the Job order in the grid and click the “View Postings” button.
  7. To drill-down and see the details of a given Job, click on the Job order in the grid and click the “View Detail” button.

When are costs accumulated and posted to the General Ledger?

  1. The process of issuing credits the Inventory account and debits the WIP account. Additional information can be found on the Job Reporting page.
  2. Posting payroll. Job costs will sit in WIP Labor until the Job is closed. If payroll is not posted until the Job is closed, postings will skip the WIP account entirely.
  3. Purchasing against a Job, such as non-stock parts or hiring outside painters.

How are production costs displayed on reports?

Using the Accounting > Options > Costing tab's "Cost Expression". The system will use the result of the expression entered to populate the production cost for material finished on Jobs. This expression use supports scenarios where the cost of finished material can not be done by volume or weight alone and must be calculated based on multiple factors and values. Keep in mind that the expression entered and results do not affect the GL; they are only used for reporting purposes.

What can production costs be used to determine?

Calculating production costs for Jobs is necessary to ensure that the material is being produced at a reasonable cost and can be sold at the proper price point. Proactively maintaining accurate production costs, i.e. before sending a Quote to a customer, ensures that the company is only spending the necessary amount to produce the material while receiving the maximum profit. To determine production costs, generate a Job Reporting "Job Cost Summary" report with a view of Closed Jobs and other pre-filters as desired. This report displays the production costs for the Jobs listed, including labor and burden, and provides the variance between standard and actual costs. The summary report is used for this purpose as opposed to the detail report since the detail report may not include labor and burden, if those costs are added at the end of the Job. To determine the cost of materials only and ignore labor, run a "Job Material Cost Detail" report. For information on determining sales profits, refer to the Sales Reporting page.

In what order should the available Job Reporting reports be used?

  1. Job Cost Summary - This report displays the total cost for the Job and should be used first.
    1. The calculations used for the variable in this report can be found on the Job Reporting page.
  2. Job Cost Detail - This report displays line by line detail and should be used second.
    1. Labor, Materials, and Burden are posted to the Job, not individual lines, so users cannot drill into Labor by line.
    2. Users can ignore Acct. Labor and Burden on this report since process-wise they will not be posted to Job before a finish is recorded.
  3. Job Material Cost Detail - This report, which displays each line’s material usage vs plan, may be used to analyze the material usage and costs on a job.
  4. Production Summary - Displays summary of all finishes for a job including Part #, Planned Qty, Finished Qty and Total Catch Weight if applicable. This report can be used to view all job general ledger postings and to un- finish, if necessary. You may also View Detail of all finishes by job line.
  5. Production Detail - Displays Part #, Description, Location, Completed date/time, Planned Qty and Finish Qty for each job finish. This report can be used to view finish general ledger postings and to un- finish, if necessary.
  6. Production Costs - Displays Actual Labor and Burden vs. Standard Labor and Burden individually, or combination, in hierarchical fashion by:
    1. Job
    2. Operation
    3. Shift
    4. Shop Area
    5. Work Center
    6. Work Crew
  7. QC Summary - Displays # of Passes, Passed and Failed Test Count for each job line. This report can be used to evaluate QC results at a summary level and View Details to see specific passed / failed tests and results.
  8. QC Detail - Displays all QC test results for all passes by job and line (Part Number).